﻿CREATE PROCEDURE [dbo].[proc_ContratosRefeicoesPrecoLoadAll]
AS
BEGIN

	SET NOCOUNT ON
	DECLARE @Err int

	SELECT
		cr.[IdRefeicaoContratada],
		cr.[CodTipoServico],
		cr.[Preco],
		cr.[DataCriacao],
		cr.[DataAlteracao],
		t.Descricao as DescricaoTipoServico,
		t.DescricaoCurta as DescricaoCurtaTipoServico,
		t.Simbolo as SimboloTipoServico,
		t.Tipo as TipoServico
	FROM [ContratosRefeicoesPreco] cr
		inner join Tipologias t on cr.CodTipoServico = t.Codigo
	SET @Err = @@Error

	RETURN @Err
END
